UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wziBYgG/qdaBiLKPUieVDOTHkxMtdoqFpXlLxBFTFOY='
WHERE
key_id = '9bde59577b6e046199a9e07bf9ee3b685bf73e238d42cf821f2b182803b63e0a'
AND (
token = 'wziBYgG/qdaBiLKPUieVDOTHkxMtdoqFpXlLxBFTFOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)