UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yNZ6NmLaFeExUtLN5CQ5wCCuvbhypgnpZeK4Up4dgY='
WHERE
key_id = '336e5751ae49b3e42be51025246b5c4973cdafb3df17b821fd6b0018b2bd4fe0'
AND (
token = '0yNZ6NmLaFeExUtLN5CQ5wCCuvbhypgnpZeK4Up4dgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)