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