UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNnWfwlL42qhbyLNGm16G7XcHn6mi3dWYWGbvehcbaQ='
WHERE
key_id = '0ffb906ea6378f7584d119579867c76f2bf51b7914464c43d404deae6dfb0472'
AND (
token = 'tNnWfwlL42qhbyLNGm16G7XcHn6mi3dWYWGbvehcbaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)