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