UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mSW3P/wZAHkENcyXX2y4xgXo6uH/nF14VV2bcBsr0TE='
WHERE
key_id = 'f638646248dcc98e1da9a3550470bb341130ada961d53f1c9d1512a44f47ed1d'
AND (
token = 'mSW3P/wZAHkENcyXX2y4xgXo6uH/nF14VV2bcBsr0TE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)