UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lM0gQwBPbfXJyI8IrOBU5SJfWMRmv1djPNH6SbxFLyk='
WHERE
key_id = '72c227ca5779bd3c33f8bba7a6111652447abb59e06d58d407d336b6e4f77fd0'
AND (
token = 'lM0gQwBPbfXJyI8IrOBU5SJfWMRmv1djPNH6SbxFLyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)