UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tE+BhDuC3bzjIqzivZ2cNW8icHMVhTSaeBmf7PFs4w='
WHERE
key_id = '47fbe2183ce5aad76f5f0cd2428b0e7de544288770059104273823dc80814a13'
AND (
token = '9tE+BhDuC3bzjIqzivZ2cNW8icHMVhTSaeBmf7PFs4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)