UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QzYvCCLFbXYwNO5dZZZxBPe2F7pNFoQHPkyqO7y2eQc='
WHERE
key_id = '59b4644c1c02e194364e524b7e6c333901a037a2c91890273e7304a9f097a2fb'
AND (
token = 'QzYvCCLFbXYwNO5dZZZxBPe2F7pNFoQHPkyqO7y2eQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)