UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9K0OkHhnu5clWFxolUOtIjy8gbE1YYVEW4p5fyLeiuU='
WHERE
key_id = '0bb528f665e5bae094f5b943da8bb3ca20379fa75ad30ddf0b59bfab43068418'
AND (
token = '9K0OkHhnu5clWFxolUOtIjy8gbE1YYVEW4p5fyLeiuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)