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