UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtG6pxX02C/dWhiRJ/IAvFtPJ01YU/Xg3Ho2T/GPY3c='
WHERE
key_id = '0b5ec1ade5fbdfff95ccc1faafc611e7997ee542f4f9ecf02eb4ae4687052241'
AND (
token = 'KtG6pxX02C/dWhiRJ/IAvFtPJ01YU/Xg3Ho2T/GPY3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)