UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXSlw4agcf3JsI9tfxGoEjTkfCFnaZkcn/fpXJv7kOI='
WHERE
key_id = '7a5ac937b0870caac8f32738cf745897f23a1115513363b8e60c117df6795676'
AND (
token = 'qXSlw4agcf3JsI9tfxGoEjTkfCFnaZkcn/fpXJv7kOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)