UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHtiV51MzuvEfe5hv5aZuxhtlaDJEqga9hs7b7dgdkg='
WHERE
key_id = '46a7a2a3ac525669cedb11355db2c6bca927a5a2d37821684f5d5d71c29a33fa'
AND (
token = 'tHtiV51MzuvEfe5hv5aZuxhtlaDJEqga9hs7b7dgdkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)