UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYiVkgaz91Mys+mOaVTDq8Q0YkzUc94pXcs6MKqERug='
WHERE
key_id = '6ea8ea136afdc0308b801835a51107920e3276ba608767072045c5a0e6968e62'
AND (
token = 'nYiVkgaz91Mys+mOaVTDq8Q0YkzUc94pXcs6MKqERug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)