UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uqMZi7hRvSn3k8SXzDClzVd8vGXmLjeUgEgzp4nTWoU='
WHERE
key_id = '5b5a43a37c862536a629b41628b6f4b6c61c60843b862f0765085bb5518571b4'
AND (
token = 'uqMZi7hRvSn3k8SXzDClzVd8vGXmLjeUgEgzp4nTWoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)