UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04sL7b8qZuStVclUZzsLevUEmwIS1CApBgbvpgJGd1g='
WHERE
key_id = '318636fb284eac2ce5fae28a6bf33de1a128ddf45b9abcdcda9b7b2bf02c2620'
AND (
token = '04sL7b8qZuStVclUZzsLevUEmwIS1CApBgbvpgJGd1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)