UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QPN7kclZg3MYZi5tQ8W4Cipzdq8yEFIF6cQnE7FOt4='
WHERE
key_id = 'ed5d966ffac70aff142c3caeee8a5ed095273c0c69753bcb25762e05069d8df6'
AND (
token = '9QPN7kclZg3MYZi5tQ8W4Cipzdq8yEFIF6cQnE7FOt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)