UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NsgGaAzhuIiUYQBQiI9BNVLze/VCRWth282ExxiEI4k='
WHERE
key_id = 'a0abb8f6d65ca72f8ad730474c9319b371f73a2c232c092ccc91116dfe86b9ec'
AND (
token = 'NsgGaAzhuIiUYQBQiI9BNVLze/VCRWth282ExxiEI4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)