UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o/+PXfiKUlXvOMoaUO2nbd2Zh+tSsYI2JCef950fkUs='
WHERE
key_id = '9e5748f9c0b165920673c5cab4500174c1855802d1ca8aed965503162cd55f08'
AND (
token = 'o/+PXfiKUlXvOMoaUO2nbd2Zh+tSsYI2JCef950fkUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)