UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4Agp72cUr8DatRpqiXQlCY5e8f21InIKR8zfXH0ZS8='
WHERE
key_id = 'a7b34f90444796891dc62e80a9fb59446a52ab76beafff56d950facfea91741c'
AND (
token = 'd4Agp72cUr8DatRpqiXQlCY5e8f21InIKR8zfXH0ZS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)