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