UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PrgHXwm05sD7FpHu2Gm2t10/xaTvco9hSchYWtys1b0='
WHERE
key_id = '9baaa4e0c5aa8a3e8acdc8a2fb24325917969490bdbf926f209b251a41d77363'
AND (
token = 'PrgHXwm05sD7FpHu2Gm2t10/xaTvco9hSchYWtys1b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)