UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WD5sopzEUZ+5CkqRxKZ5ZXF5S8Qu81255gG77mPbLk='
WHERE
key_id = 'e9c17644adf20d90b034d7d5d6a49fd97e6d27f94df137d0545670f57f5e4d06'
AND (
token = '7WD5sopzEUZ+5CkqRxKZ5ZXF5S8Qu81255gG77mPbLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)