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