UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbk7IbWEy5b2nIYlK7yrODW+HAWdwXyYD8Ec9LgktTI='
WHERE
key_id = 'ffcce72918e5f5cdfeac8c8872bbe732c15c0cbdb584e4b7aced36360771617a'
AND (
token = 'hbk7IbWEy5b2nIYlK7yrODW+HAWdwXyYD8Ec9LgktTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)