UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdCCc2NO6J7qBfLletNvKsV6XuGmtA1ehMSATKHgGKI='
WHERE
key_id = 'bb8bc0ff77ab2cc28b424d6c638add9b84d0c33e9632325db4aa39e3645a4a61'
AND (
token = 'QdCCc2NO6J7qBfLletNvKsV6XuGmtA1ehMSATKHgGKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)