UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ENug4rUq9gHqnW6pRKdToXxFlf+eVOSIygu6EZLAV+M='
WHERE
key_id = '47cb34e6b40249326e7ce5e92e43470639293e6d2bdee571262ba60144102fd1'
AND (
token = 'ENug4rUq9gHqnW6pRKdToXxFlf+eVOSIygu6EZLAV+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)