UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVGS0Ngnb4RVmoP8wV94EJVot/4WgGy7hsl69ZlW/rk='
WHERE
key_id = '5046402acbb40d644f0de06179f2dbcace50bdc054a039b34f993b353013d1aa'
AND (
token = 'VVGS0Ngnb4RVmoP8wV94EJVot/4WgGy7hsl69ZlW/rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)