UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqphHzYi7CrJNUQ+ajNxbwDZ24Wj9BgHLk4/ZJuMgGY='
WHERE
key_id = 'e9166f35c849139d831e81e1a659687dae4cd6b0c3623d0e6592a0d1dccee11e'
AND (
token = 'TqphHzYi7CrJNUQ+ajNxbwDZ24Wj9BgHLk4/ZJuMgGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)