UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsGH0N4S28OeWAYRF1adUmDI+HgwisLO4zQkRfF5+6g='
WHERE
key_id = '7d944380a464ebc03f9259689d8ed60494d20cca123ed575e77d7c4cd67d7351'
AND (
token = 'zsGH0N4S28OeWAYRF1adUmDI+HgwisLO4zQkRfF5+6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)