UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IZloSydIKc2HSy/sbgLgdgUKL//lk8Spf0L9/akxA6g='
WHERE
key_id = 'e07b958b09b1ded5fb1bb83068d843939cb722a0cf17c530248776d75a9e0896'
AND (
token = 'IZloSydIKc2HSy/sbgLgdgUKL//lk8Spf0L9/akxA6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)