UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IcXDrOeW7MroBeEQN/afsh9IK0ffSMhtbPqIjGUukTM='
WHERE
key_id = '7f948022a858743ed5ac391623643b0f3b1ed5e2a8fded7269e279e9bdefe859'
AND (
token = 'IcXDrOeW7MroBeEQN/afsh9IK0ffSMhtbPqIjGUukTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)