UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgnBZplsRba//5Y6YjJNiS2+faDJVAnLUaSv/v8DsGY='
WHERE
key_id = '5933d2ba556199405bd361bc2b3f5f78b1aea6988e502d18ecb2f6ff306a87fe'
AND (
token = 'JgnBZplsRba//5Y6YjJNiS2+faDJVAnLUaSv/v8DsGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)