UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pl9/bqGmElWY77eMPUoo1CbW15VUdfh7fVaEk53Ngj4='
WHERE
key_id = 'be9aa58f9d2d2c9c7d1e30f7ddee506eb4b24fcb4b091b453a7cfd360613f7de'
AND (
token = 'Pl9/bqGmElWY77eMPUoo1CbW15VUdfh7fVaEk53Ngj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)