UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CgkXZ5hAskCZ0lgBshE/ekDBxgckJ2yIbXhqT87YUA='
WHERE
key_id = '941c2c529b225824f2dda47e0b0e9a99ac8a599d05485ef48316899a55724273'
AND (
token = '8CgkXZ5hAskCZ0lgBshE/ekDBxgckJ2yIbXhqT87YUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)